<?php
	namespace org\kahikai\database\mysql;
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Cp1252"/>
<meta name="author" content="Ch4mp"/>
<link rel="shortcut icon" href="../../../../../favicon.ico" type="image/x-icon"/> 
<link rel="icon" href="../../../../../favicon.ico" type="image/x-icon"/>
<title>MysqlPaperDao test</title>
</head>
<body>
<?php
	require_once '../../../../../org/kahikai/database/mysql/MysqlPaperDao.php';
	
	use org\kahikai\database\mysql\MysqlPaperDao;
	
	$paperDao = new MysqlPaperDao();
	
	echo "<h1>getAll()</h1>\n";
	echo "<p>";
	foreach($paperDao->getAll() as $speciesId => $speciesPapers) {
		echo "Species#$speciesId: ";
		$first = true;
		foreach($speciesPapers as $paper) {
			if($first) {
				$first = false;
			} else {
				echo ', ';
			}
			echo "($paper->id, $paper->url)";
		}
		echo "<br/>\n";
	}
	echo "</p>\n";
	
	echo "<h1>getById(1)</h1>\n";
	$paper = $paperDao->getById(1);
	echo "<p>$paper->id: $paper->url</p>\n";
	
	echo "<h1>getById(-1)</h1>\n";
	$paper = $paperDao->getById(-1);
	echo "<p>" . (isset($paper) ? 'shouldn\'t be set' : 'null') . "</p>\n";
	
	echo "<h1>getBySpeciesId(1)</h1>\n";
	echo "<p>";
	foreach($paperDao->getBySpeciesId(1) as $paper) {
		echo "$paper->id: $paper->url<br/>\n";
	}
	echo "</p>\n";
	
	echo "<h1>getBySpeciesId(2)</h1>\n";
	echo "<p>";
	foreach($paperDao->getBySpeciesId(2) as $paper) {
		echo "<a href=\"$paper->url\">$paper->id: $paper->url</a><br/>\n";
	}
	echo "</p>\n";
	
	echo "<h1>getBySpeciesId(-1)</h1>\n";
	echo "<p>";
	foreach($paperDao->getBySpeciesId(-1) as $paper) {
		echo "<a href=\"$paper->url\">$paper->id: $paper->url</a><br/>\n";
	}
	echo "</p>\n";
?>
</body>
</html>